delete from [Account]
delete from [Category]
delete from [Charge]
GO

-- Account
INSERT INTO [Account] (Name) VALUES('Visa')
INSERT INTO [Account] (Name) VALUES('Bank Checking')
INSERT INTO [Account] (Name) VALUES('Credit Union Savings')
GO

-- Category
INSERT INTO [Category] (Name,Mask) VALUES('CAR EXPENSES','PARKIN')    
INSERT INTO [Category] (Name,Mask) VALUES('COFFEE','STARBUCKS|COFFEE')          
INSERT INTO [Category] (Name,Mask) VALUES('DENTAL','DENTAL|ENDODONTICS')          
INSERT INTO [Category] (Name,Mask) VALUES('EATING OUT','SEAFOOD|GRILL')      
INSERT INTO [Category] (Name,Mask) VALUES('ENTERTAINMENT','BOAT RENTALS')   
INSERT INTO [Category] (Name,Mask) VALUES('GAS','UNION 76|CHEVRON')             
INSERT INTO [Category] (Name,Mask) VALUES('GIFT','PHOTO SERV')            
INSERT INTO [Category] (Name,Mask) VALUES('GROCERIES','SAFEWAY|CTRL MKT')       
INSERT INTO [Category] (Name,Mask) VALUES('GYM','FITNESS')             
INSERT INTO [Category] (Name,Mask) VALUES('HOME EXPENSES','USPS|BEST BUY|GOODWILL')   
INSERT INTO [Category] (Name,Mask) VALUES('HOME IMPROVEMENTS','HOME DEPOT')   
INSERT INTO [Category] (Name,Mask) VALUES('INTERNET','COMCAST')            
INSERT INTO [Category] (Name,Mask) VALUES('MEDICAL','HOSPITAL')             
INSERT INTO [Category] (Name,Mask) VALUES('PHONE','PHONE CARD')               
GO

-- Charge
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/12/2004','DENTAL HEALTH SERV INC',17.75,1,3)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/12/2004','USPS',21.67,1,10)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/12/2004','SEAFOOD GRILL',127.00,1,4)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/13/2004','STARBUCKS USA',2.79,1,2)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/13/2004','UNION 76',49.41,1,6)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/15/2004','SAFEWAY STORE',3.69,1,8)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/15/2004','PHOTO SERV INC',5.46,1,7)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/15/2004','CTRL MKT',99.23,1,8)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/16/2004','COFFEE ROASTER',22.69,1,2)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/16/2004','BOAT RENTALS',14.00,1,5)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/16/2004','CHEVRON',41.41,1,6)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/17/2004','BEST BUY',42.49,1,10)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/18/2004','CTRL MKT',12.70,1,8)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/18/2004','THE HOME DEPOT',9.17,1,11)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/19/2004','PORT OF CITY PARKIN',4.00,1,1)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/19/2004','ENDODONTICS PS',36.60,1,3)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/19/2004','PHONE CARD',20.00,1,14)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/20/2004','GOODWILL',21.74,1,10)
INSERT INTO [Charge] (Time,Name,Amount,AccountId,CategoryId) VALUES('09/20/2004','STARBUCKS USA',3.37,1,2)
GO

